--查询和删除的一些操作
--select * from goods
--select * from goodsclass
--drop table goods
--drop table goodsclass
--drop sequence sequence_goods
--drop sequence sequence_goodsclass


--创建商品信息表
create table goods(

       go_id number(5) primary key,
       go_name varchar2(200),
       go_salesvolume number(10),
       go_praise number(1),
       go_uptime Date,
       go_pictureurl varchar2(100),
       go_describe varchar2(200),
       go_cost number(10),
       go_price number(10),
       go_stock number(5),
       go_state number(1),
       cl_id number(3),
       go_seckill number(1)
)

--创建商品信息表的ID序列
create sequence sequence_goods
start with 10001
increment by 1

--插入商品信息表的数据
--男装
--外套
insert into goods values(sequence_goods.nextval,'花花公子夹克男修身加绒加厚2018新品男',1000,4,sysdate,'coat-1.png','商品描述',300,279,5,1,110,0);
insert into goods values(sequence_goods.nextval,'高梵 羽绒服男中长款加厚连帽商务男生冬',100,4,sysdate,'coat-2.png','商品描述',650,600,5,1,110,0);
insert into goods values(sequence_goods.nextval,'南极人 夹克男 2018秋季新款潮流男士连',500,4,sysdate,'coat-3.png','商品描述',200,158,5,1,110,0);
insert into goods values(sequence_goods.nextval,'外套男装秋冬季新款修身短牛仔夹克男秋',500,4,sysdate,'coat-4.png','商品描述',150,138,5,1,110,0);
insert into goods values(sequence_goods.nextval,'2018新款男士韩版潮流工装棉衣冬季棉服',1000,4,sysdate,'coat-5.png','商品描述',300,278,5,1,110,0);
--羽绒服
insert into goods values(sequence_goods.nextval,'唐狮2018冬季新品羽绒服男短款连帽加厚',1000,4,sysdate,'DJ-1.png','商品描述',300,278,5,1,111,0);
insert into goods values(sequence_goods.nextval,'花花公子 羽绒服男2018冬季鸭绒轻薄加',1000,4,sysdate,'DJ-2.png','商品描述',600,568,5,1,111,0);
insert into goods values(sequence_goods.nextval,'七匹狼羽绒服男中长款2018冬季新品时尚',1000,4,sysdate,'DJ-3.png','商品描述',780,750,5,1,111,0);
insert into goods values(sequence_goods.nextval,'花花公子 羽绒服男 新品短款加厚宽松连',1000,4,sysdate,'DJ-4.png','商品描述',300,278,5,1,111,0);
insert into goods values(sequence_goods.nextval,'木林森正品冬季中长款羽绒服男款新品外',1000,4,sysdate,'DJ-5.png','商品描述',300,278,5,1,111,0);
--......更多数据
--女装
--毛呢外套
insert into goods values(sequence_goods.nextval,'2018冬季新款羊剪绒大衣女中长款复合皮毛一体羊毛',1000,4,sysdate,'womenCoat-1.png','商品描述',300,278,5,1,120,0);
insert into goods values(sequence_goods.nextval,'羊剪绒大衣女海宁皮草2018冬季新款皮毛一体中长款',1000,4,sysdate,'womenCoat-2.png','商品描述',300,278,5,1,120,0);
insert into goods values(sequence_goods.nextval,'M家驼色羊绒大衣女中长款2018新款高端秋冬季赫本',1000,4,sysdate,'womenCoat-3.png','商品描述',300,278,5,1,120,0);
insert into goods values(sequence_goods.nextval,'毛呢外套女2018新款韩版流行双面羊绒中长款秋冬潮',1000,4,sysdate,'womenCoat-4.png','商品描述',300,278,5,1,120,0);
insert into goods values(sequence_goods.nextval,'双面羊绒大衣女中长款韩版2018新款高端复古单排扣',1000,4,sysdate,'womenCoat-5.png','商品描述',300,278,5,1,120,0);

--毛针织衫
insert into goods values(sequence_goods.nextval,'韩国东大门2018秋冬新款百搭慵懒风圆领毛衣打底衫',1000,4,sysdate,'knit-1.png','商品描述',300,278,5,1,122,0);
insert into goods values(sequence_goods.nextval,'2018新款韩版牦牛绒毛衣女宽松套头中长款慵懒chic',1000,4,sysdate,'knit-2.png','商品描述',300,278,5,1,122,0);
insert into goods values(sequence_goods.nextval,'恒源祥羊毛衫女秋冬装短款2018新款宽松半高领针织',1000,4,sysdate,'knit-3.png','商品描述',300,278,5,1,122,0);
insert into goods values(sequence_goods.nextval,'安小落自制纯色花瓣领慵懒风毛衣甜美大码宽松长袖',1000,4,sysdate,'knit-4.png','商品描述',300,278,5,1,122,0);
insert into goods values(sequence_goods.nextval,'米色山羊绒衫连帽针织衫女羊毛宽松显瘦外套秋冬卫',1000,4,sysdate,'knit-5.png','商品描述',300,278,5,1,122,0);
--...更多数据
--鞋靴
--流行女鞋
insert into goods values(sequence_goods.nextval,'毛毛鞋女秋冬外穿阿希哥同款网红白色羊羔毛2018新',1000,4,sysdate,'womenShoe-1.png','商品描述',300,278,5,1,130,0);
insert into goods values(sequence_goods.nextval,'2019春季新款 真皮小皮鞋女英伦风女鞋 黑色漆皮粗跟',1000,4,sysdate,'womenShoe-2.png','商品描述',300,278,5,1,130,0);
insert into goods values(sequence_goods.nextval,'寻锦家 高跟短靴女瘦瘦靴防水台扁扁跟弹力秋冬方头',1000,4,sysdate,'womenShoe-3.png','商品描述',300,278,5,1,130,0);
insert into goods values(sequence_goods.nextval,'内增高小熊运动鞋女2018秋冬季新款老爹鞋加绒网',1000,4,sysdate,'womenShoe-4.png','商品描述',300,278,5,1,130,0);
insert into goods values(sequence_goods.nextval,'小白鞋女冬季加绒2018新款松糕鞋厚底内增高女鞋网',1000,4,sysdate,'womenShoe-5.png','商品描述',300,278,5,1,130,0);
--短靴
insert into goods values(sequence_goods.nextval,'大东切尔西靴女2018冬季新款欧美中粗跟加绒',1000,4,sysdate,'sb-1.png','商品描述',300,278,5,1,131,0);
insert into goods values(sequence_goods.nextval,'马丁靴男中帮潮英伦真皮军靴工装短靴子冬季加绒雪',1000,4,sysdate,'sb-2.png','商品描述',300,278,5,1,131,0);
insert into goods values(sequence_goods.nextval,'马丁靴女2018新款棉鞋冬英伦风机车军靴网红短靴真',1000,4,sysdate,'sb-3.png','商品描述',300,278,5,1,131,0);
insert into goods values(sequence_goods.nextval,'雪地靴女羊皮毛一体棉鞋女短靴四叶草可爱狐狸毛球',1000,4,sysdate,'sb-4.png','商品描述',300,278,5,1,131,0);
insert into goods values(sequence_goods.nextval,'2018新款雪地靴女冬短筒厚底马丁靴短靴百搭韩版保',1000,4,sysdate,'sb-5.png','商品描述',300,278,5,1,131,0);
--...更多数据

--手机
--华为
insert into goods values(sequence_goods.nextval,'华为畅享7 Plus（TRT-AL00)',1000,4,sysdate,'huawei-1.png','商品描述',300,278,5,1,140,0);
insert into goods values(sequence_goods.nextval,'HUAWEI/华为麦芒6 4GB+64GB 曜石黑 ',1000,4,sysdate,'huawei-2.png','商品描述',300,278,5,1,140,0);
insert into goods values(sequence_goods.nextval,'华为nova2s 6GB+128GB 曜石黑',1000,4,sysdate,'huawei-3.png','商品描述',300,278,5,1,140,0);
insert into goods values(sequence_goods.nextval,'Huawei/华为畅享7S 3GB+32GB金色移动',1000,4,sysdate,'huawei-4.png','商品描述',300,278,5,1,140,0);
insert into goods values(sequence_goods.nextval,'HUAWEI/华为 Mate10 4GB+64GB',1000,4,sysdate,'huawei-5.png','商品描述',300,278,5,1,140,0);
--iphone
insert into goods values(sequence_goods.nextval,'Apple iPhone 8 Plus 64GB 金色 移动联通',1000,4,sysdate,'iphone-1.png','商品描述',300,278,5,1,144,0);
insert into goods values(sequence_goods.nextval,'Apple iPhone 7 Plus 32GB 亮黑色 移动联',1000,4,sysdate,'iphone-2.png','商品描述',300,278,5,1,144,0);
insert into goods values(sequence_goods.nextval,'Apple iPhone SE 全网通4G 苹果手机',1000,4,sysdate,'iphone-3.png','商品描述',300,278,5,1,144,0);
insert into goods values(sequence_goods.nextval,'Apple iPhone 6s Plus 32G 金色 移动联通电',1000,4,sysdate,'iphone-4.png','商品描述',300,278,5,1,144,0);
insert into goods values(sequence_goods.nextval,'Apple iPhone 5s 16G 金色 移动联通4G手机',1000,4,sysdate,'iphone-5.png','商品描述',300,278,5,1,144,0);
--...更多数据

--箱包
--钱包
insert into goods values(sequence_goods.nextval,'金利来（Goldlion）钱包男士商务头层牛皮横款钱夹多卡位简约皮夹短款票夹 黑',1000,4,sysdate,'wallet-1.png','商品描述',300,278,5,1,150,0);
insert into goods values(sequence_goods.nextval,'稻草人（MEXICAN）男士钱包头层牛皮商务休闲长款多功能超薄钱夹',1000,4,sysdate,'wallet-2.png','商品描述',300,278,5,1,150,0);
insert into goods values(sequence_goods.nextval,'ClearKing钱包 男士真皮短款商务头层牛皮 横款两折钱夹皮夹多功能票夹男 2018',1000,4,sysdate,'wallet-3.png','商品描述',300,278,5,1,150,0);
insert into goods values(sequence_goods.nextval,'CHARLESKEITH 女包CK6-10840136金属提把翻盖式钱包 紫红色 XS',1000,4,sysdate,'wallet-4.png','商品描述',300,278,5,1,150,0);
insert into goods values(sequence_goods.nextval,'金狐狸（FOXER）女士钱包女长款牛皮钱夹狐狸按扣大容量女士手拿包多卡位搭扣',1000,4,sysdate,'wallet-5.png','商品描述',300,278,5,1,150,0);
--双肩包
insert into goods values(sequence_goods.nextval,'维多利亚旅行者 VICTORIATOURIST 双肩包电脑包15.6英寸 男商务防水双肩背包V9006灰色',1000,4,sysdate,'backpack-1.png','商品描述',300,278,5,1,152,0);
insert into goods values(sequence_goods.nextval,'博牌Bopai双肩背包男充电防盗旅行包15.6英寸电脑包多功能出差帆布包',1000,4,sysdate,'backpack-2.png','商品描述',300,278,5,1,152,0);
insert into goods values(sequence_goods.nextval,'美旅AmericanTourister明星同款韩版双肩背包 笔记本电脑包男女书包双肩包',1000,4,sysdate,'backpack-3.png','商品描述',300,278,5,1,152,0);
insert into goods values(sequence_goods.nextval,'真皮背包女牛皮双肩包女真皮背包女2018新款书包潮韩版休闲软皮旅行女包 S61黑色',1000,4,sysdate,'backpack-4.png','商品描述',300,278,5,1,152,0);
insert into goods values(sequence_goods.nextval,'老人头（LAORENTOU）双肩包女潮流女包牛皮港风学生书包旅行休闲女士多功能背包 JD9087J039L1A 黑色',1000,4,sysdate,'backpack-5.png','商品描述',300,278,5,1,152,0);
--...更多数据












--创建商品分类表
create table goodsclass(

     cl_id number(3) primary key,
     cl_name varchar2(100),
     fa_id number(3),
     cl_describe varchar2(200)

)

--创建商品分类表的ID序列
create sequence sequence_goodsclass
start with 101
increment by 1

--插入商品分类表的数据
insert into goodsclass values(sequence_goodsclass.nextval,'男装',100,'男人穿了帅气');
insert into goodsclass values(sequence_goodsclass.nextval,'女装',100,'女人穿了美丽');
insert into goodsclass values(sequence_goodsclass.nextval,'鞋靴',100,'就是鞋子');
insert into goodsclass values(sequence_goodsclass.nextval,'手机',100,'不然呢');
insert into goodsclass values(sequence_goodsclass.nextval,'箱包',100,'能装下整个世界');
insert into goodsclass values(sequence_goodsclass.nextval,'美妆',100,'媲美易容术');
insert into goodsclass values(sequence_goodsclass.nextval,'零食',100,'饿了吗');
insert into goodsclass values(sequence_goodsclass.nextval,'办公',100,'工作必备');
insert into goodsclass values(sequence_goodsclass.nextval,'笔记本',100,'买买买');
--男装分类
insert into goodsclass values(sequence_goodsclass.nextval,'外套',101,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'羽绒服',101,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'棉衣',101,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'夹克',101,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'卫衣',101,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'衬衫',101,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'T恤',101,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'休闲裤',101,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'牛仔裤',101,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'针织衫',101,'买买买');
--女装分类
insert into goodsclass values(sequence_goodsclass.nextval,'毛呢外套',102,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'羽绒服',102,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'毛针织衫',102,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'连衣裙',102,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'短外套',102,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'T恤',102,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'衬衫',102,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'休闲裤',102,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'牛仔裤',102,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'日韩清新',102,'买买买');
--鞋靴分类
insert into goodsclass values(sequence_goodsclass.nextval,'流行女鞋',103,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'短靴',103,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'高跟鞋',103,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'休闲鞋',103,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'马丁靴',103,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'高帮鞋',103,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'男鞋',103,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'正装商务',103,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'运动风',103,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'加绒鞋',103,'买买买');
--手机
insert into goodsclass values(sequence_goodsclass.nextval,'华为',104,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'小米',104,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'oppo',104,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'vivo',104,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'iPhone',104,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'一加',104,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'锤子',104,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'魅族',104,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'黑鲨',104,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'努比亚',104,'买买买');
--箱包分类
insert into goodsclass values(sequence_goodsclass.nextval,'钱包',105,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'真皮包',105,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'双肩包',105,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'旅行箱',105,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'小方包',105,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'贝壳包',105,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'单肩包',105,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'手提包',105,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'男士商务',105,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'欧美潮搭',105,'买买买');
--美妆分类
insert into goodsclass values(sequence_goodsclass.nextval,'面膜',106,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'洁面',106,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'防晒',106,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'面霜',106,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'卸妆',106,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'香水',106,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'爽肤水',106,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'BB霜',106,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'眼线',106,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'口红',106,'买买买');
--零食分类
insert into goodsclass values(sequence_goodsclass.nextval,'牛肉干',107,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'面包',107,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'辣条',107,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'饼干',107,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'巧克力',107,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'芒果干',107,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'薯片',107,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'瓜子',107,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'糖果',107,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'猪肉脯',107,'买买买');
--办公分类
insert into goodsclass values(sequence_goodsclass.nextval,'打印机',108,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'复合机',108,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'投影机',108,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'保险箱',108,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'电脑桌',108,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'办公椅',108,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'计算器',108,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'中性笔',108,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'马克笔',108,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'本册',108,'买买买');
--笔记本分类
insert into goodsclass values(sequence_goodsclass.nextval,'戴尔',109,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'联想',109,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'ThinkPad',109,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'华硕',109,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'宏基',109,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'外星人',109,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'神舟',109,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'Apple',109,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'三星',109,'买买买');
insert into goodsclass values(sequence_goodsclass.nextval,'小米',109,'买买买');

























